Prolog Ltd. is a small wholesaler of powerful microcomputers. In recent months, it has been selling 50 machines a month at a price of $2,000 each. These machines cost $1,600 each. A new model has just been launched and this is expected to offer greatly enhanced performance. Its selling price and cost will be the same as for the old model. From the beginning of January 2011, sales are expected to increase at a rate of 20 machines each month until the end of June 2011, when sales will amount to 170 units per month. They are expected to continue at that level thereafter. Operating costs, including depreciation of $2,000 a month, are forecast as follows:
Prolog expects to receive no credit for operating costs. Additional shelving for storage costing $12,000 will be bought, installed, and paid for in April. Corporate tax of $25,000 is due at the end of March. Prolog expects that customers will take two months to pay. To give its customers a good level of service, Prolog plans to hold enough inventory at the end of each period to fulfill anticipated demand in the following month. The computer manufacturer, however, grants one month's credit to Prolog. Prolog Ltd.'s balance sheet is shown below.
Required:
(a) Prepare a projected cash budget for Prolog Ltd., showing the cash balance or required overdraft for each month in the six months ending June 30, 2011.
(b) State briefly what further information a banker would require from Prolog before granting additional overdraft privileges for the anticipated expansion of sales.
SOLUTION
Prolog Ltd.
(a) The cash budget projection for the six months ended June 30, 2011 is:
| Jan $000 | Feb $000 | Mar $000 | Apr $000 | May $000 | June $000 | |
|---|---|---|---|---|---|---|
| Receipts | ||||||
| Credit sales | 100 | 100 | 140 | 180 | 220 | 260 |
| Payments | ||||||
| Accounts payable | 112 | 144 | 176 | 208 | 240 | 272 |
| Operating expenses | 4 | 6 | 8 | 10 | 10 | 10 |
| Furniture and fixtures (shelving) | – | – | – | 12 | – | – |
| Income taxes | ___ | ___ | 25 | ___ | ___ | ___ |
| 116 | 150 | 209 | 230 | 250 | 282 | |
| Net cash flow | (16) | (50) | (69) | (50) | (30) | (22) |
| Opening balance | (68) | (84) | (134) | (203) | (253) | (283) |
| Closing balance | (84) | (134) | (203) | (253) | (283) | (305) |
| (b) | A banker may require various pieces of information before granting additional overdraft privileges. These may include the following: |
Unlock the complete assignment
You are viewing the free preview. Purchase this assignment once to reveal the complete resource.
Secure checkout is completed by Stripe.